SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_UpdateSpecInfo]
    (
      @fdSpecID VARCHAR(50),
      @fdSpecName NVARCHAR(50),
      @fdCollID VARCHAR(50),
      @fdSpecType INT,
      @fdSpecCampus VARCHAR(50),
      @fdSpecIntroduction NTEXT,
      @fdSpecVerifyStatus BIT,
      @fdSpecVerifyTime DATETIME,
      @fdSpecVerifyID VARCHAR(50),
      @fdSpecBachelorNumber INT,
      @fdSpecMasterNumber INT,
      @fdSpecDoctorNumber INT
    )
AS 
    UPDATE  dbo.FS_Speciality
    SET     fdSpecName = @fdSpecName,
            fdCollID = @fdCollID,
            fdSpecType = @fdSpecType
    WHERE   fdSpecID = @fdSpecID
    UPDATE  dbo.JOL_SpecialityIntroduction
    SET     fdSpecCampus = @fdSpecCampus,
            fdSpecIntroduction = @fdSpecIntroduction,
            fdSpecVerifyStatus = @fdSpecVerifyStatus,
            fdSpecVerifyID = @fdSpecVerifyID,
            fdSpecVerifyTime = @fdSpecVerifyTime,
            fdSpecBachelorNumber = @fdSpecBachelorNumber,
            fdSpecMasterNumber = @fdSpecMasterNumber,
            fdSpecDoctorNumber = @fdSpecDoctorNumber
    WHERE   fdSpecID = @fdSpecID
GO
